import pandas as pd
import numpy as np

x = pd.read_excel("E:\本科教学\大三下\数学建模\新疆大学数学建模校赛2021年度赛题及说明\A题\data.xlsx", header=None)
x = np.array(x)
print(np.array(x.shape) + 2)
print("num of column:" + str(x.size))
print(len(x.transpose()))
a = np.vstack((x[:, 1], x[:, 2]))
print(a)
a = np.vstack((np.vstack((x[:, 1], x[:, 2])), x[:, 5])).transpose()
print(a)
print(a.transpose())
